CREATE TABLE `f_target` (
`label` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 255 ) NOT NULL ,
`module` VARCHAR( 255 ) NOT NULL ,
`document_model` VARCHAR( 255 ) NOT NULL ,
`document_uid` INT( 11 ) NOT NULL ,
`document_lang` VARCHAR( 5 ) NOT NULL ,
`parent_id` INT( 11 ) NULL,
PRIMARY KEY (`document_uid`),
FOREIGN KEY (`document_uid`) REFERENCES `f_document`(`document_uid`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;